﻿if exists (select 1
            from  sysobjects
           where  id = object_id('GXBZ_EMR_XYCF')
            and   type = 'U')
   drop table GXBZ_EMR_XYCF
go

/*==============================================================*/
/* Table: GXBZ_EMR_XYCF                                         */
/*==============================================================*/
create table GXBZ_EMR_XYCF (
   YZLSH                varchar(64)          not null,
   XGBZ                 varchar(1)           not null,
   GRJBXXBSH            varchar(64)          not null,
   CXJMJKDABH           varchar(17)          not null,
   MJZBSH               varchar(32)          null,
   CFBH                 varchar(64)          null,
   JZKSDM               varchar(64)          null,
   JZKSMC               varchar(32)          null,
   YLJGDM               varchar(22)          null,
   YLJGMC               varchar(70)          null,
   KFSJ                 datetime             null,
   KFSSGH               varchar(64)          null,
   KFYSXM               varchar(30)          null,
   WDGLJGDM             varchar(22)          null,
   WDGLJGMC             varchar(70)          null,
   SHYJSGH              varchar(64)          null,
   SHYJSXM              varchar(30)          null,
   TPYJSGH              varchar(64)          null,
   TPYJSXM              varchar(30)          null,
   HDYJSGH              varchar(64)          null,
   HDYJSXM              varchar(30)          null,
   FYYJSGH              varchar(64)          null,
   FYYJSXM              varchar(30)          null,
   ZDDM                 varchar(20)          null,
   ZDMC                 varchar(100)         null,
   YWSYTJDM             varchar(6)           null,
   YWSYTJMC             varchar(100)         null,
   YWYCSL               decimal(18,4)        null,
   YWSYPL               varchar(20)          null,
   YWJXDM               varchar(3)           null,
   YWJXMC               varchar(100)         null,
   YPDMYBBM             varchar(20)          null,
   YPMC                 varchar(100)         null,
   YWSYZSL              decimal(18,4)        null,
   YPGG                 varchar(128)         null,
   CFTS                 decimal(3,0)         null,
   CFYPZH               varchar(32)          null,
   BZ                   varchar(1204)        null,
   XMJE                 decimal(10,2)        null,
   MJ                   varchar(16)          not null,
   TBRQ                 datetime             not null,
   SCZT                 varchar(1)           not null,
   CS_JYBZ              int                  not null,
   SCSJ                 datetime             not null,
   constraint PK_GXBZ_EMR_XYCF primary key (YZLSH, XGBZ)
)
go
